You may establish rules to apply for user entered value
data for query criteria based on a number of optional validation rules
as follows:You may establish rules to apply for user entered value
data for query criteria based on a number of optional validation rules
as follows:
Range Checking Validation
Input Length Validation
Case Validation
Regular Expression Validation
You may use range checking validation to limit the maximum value and/or minimum value entered by a user for a criteria value. The limit entries may be alpha, numeric, or date formats.
Input length validation ensures that the length of a user entered value is in a specified range.
More correctly, this is actually a case conversion function. If you choose to apply this option, user input will be forced to the nominated case.
Providing by far the most versatile and robust of validation rules, you may use regular expressions to validate virtually any input format. SQL Designer ships with a number of common regular expression validators and you may add your own using the regular expressions edit dialog in global settings.